package com.ruoyi.syrw.mapper;

import com.ruoyi.syrw.domain.YshslsyjcjlbBaDetail;
import com.ruoyi.syrw.domain.vo.YshslsyjcjlbBaDetailVo;
import com.ruoyi.common.core.mapper.BaseMapperPlus;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 岩石含水率试验检测记录子Mapper接口
 *
 * @author xisen
 * @date 2024-05-11
 */
public interface YshslsyjcjlbBaDetailMapper extends BaseMapperPlus<YshslsyjcjlbBaDetailMapper, YshslsyjcjlbBaDetail, YshslsyjcjlbBaDetailVo> {

    @Select("select * from report_ys_yshslsyjcjlb_ba_detail where excel_id = #{excelId} and del_flag = 0")
    List<YshslsyjcjlbBaDetail> selectListByExcelId(Long excelId);

    @Delete("delete from report_ys_yshslsyjcjlb_ba_detail where excel_id = #{excelId}")
    void deleteByExcelId(Long excelId);
}
